UPDATE `mig_db`.`lib_template` SET `email_template`='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r     \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r <head>\r 	<meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r 	<title></title>\r </head>\r <body style=\"padding:0;margin:0;\">\r 	<!-- Begin 100% Wrapping Table -->\r 	<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r 		<tr>\r 			<td style=\"padding:20px 0;\">\r 				<!-- Begin Main Template Table -->\r 				<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r 					<tr>\r 						<td colspan=\"7\">\r 							<img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r 						</td>\r 					</tr>\r 					<tr>\r 						<td colspan=\"7\" align=\"right\" style=\"margin:0;padding:10px;font-weight:bold;color:#FFFFFF;background:#AA0000;\">\r 							Auction vehicles that will end today: [auctioncount]\r 						</td>\r 					</tr>\r 					<tr>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							Model\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							Type\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							M&M code\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							Year\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							KM\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							Location\r 						</td>\r 						<td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r 							Reserve\r 						</td>\r 					</tr>\r 					[repeater]\r 					<tr>\r 						<td colspan=\"7\" style=\"background:#ececec;padding:10px 0 0;\">\r 							<!-- Begin Footer table -->\r 							<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r 								<tr>\r 									<!-- Spacing Column -->\r 									<td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r 									<!-- Main Column -->\r 									<td width=\"380\" valign=\"top\" style=\"width:380px; font-family: Arial, Sans-serif; font-size:12px;\">\r 										<p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.co.za</b></p>\r 									</td>\r 									<!-- Spacing Column -->\r 									<td width=\"380\" valign=\"top\" align=\"right\" style=\"width:380px;\">\r 										Click <a href=\"{APP_HOST}/unsubscribe/newsletter\">here</a> to unsubscribe from newsletters.\r 									</td>\r 									<!-- Spacing Column -->\r 									<td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r 								</tr>\r 							</table>\r 							<!-- /End Footer Table -->\r 						</td>\r 					</tr>\r 				</table>\r 				<!-- /End Main Template Table -->\r 			</td>\r 		</tr>\r 	</table>\r <!-- /End 100% Wrapping Table  -->\r </body>\r </html>\r ' WHERE `id`='1';

UPDATE `mig_db`.`lib_template` SET `tags`='auctioncount' WHERE `id`='1';